﻿Imports NENAData.EF
Imports NENAData.Factory

Public Class ConferenceSessionDetails
    Inherits System.Web.UI.Page

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

    End Sub

    Private Sub ReportQuery()

        'Dim x = New SQLMembership()
        'Dim db As NENA_MembershipEntities = x.GetConnection()

        '    var oEventSessionRegistration =
        '        (from esr in db.EventSessionRegistrations
        '         join ss in db.SlotSessions on esr.SlotSession.SessionId equals ss.SessionId
        '         join er in db.EventRegistrations on esr.EventRegistration.EventRegistrationID equals er.EventRegistrationID
        '         join tp in db.TransactionPayments on er.TransactionPayment.TransactionPaymentID equals tp.TransactionPaymentID
        '         join m in db.Members on er.Member.Member_ID equals m.Member_ID
        '         where er.Event.EventId == 6 &&
        '         tp.TransactionCompleted
        'orderby(esr.SlotSession.SessionId)
        '         select new
        '             {
        '                 SessionId = esr.SlotSession.SessionId,
        '                 Speaker = ss.Speaker,
        '                 Start_Time = ss.Time_Start,
        '                 Payment_Amount = tp.PaymentAmount,
        '                 Payment_ID = tp.TransactionPaymentID,
        '                 Member_ID = er.Member.Member_ID,
        '                 FirstName = m.FirstName,
        '                 LastName = m.LastName
        '             }
        '            ).ToList();

    End Sub

    Protected Sub btnReturn_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnReturn.Click
        Response.Redirect("..\default.aspx", True)
    End Sub
End Class